create view vMeetDonation as
    select min(Trans.ST_ID)                                  ST_ID,
           min(Trans.TRANSACTION_DATE)            TRANSACTION_DATE,
           -(sum(Trans.AMOUNT))                           AMOUNT,
           max(TRANS_NUMBER)                             TRANS_NUMBER,
           sum(Trans.INVOICE_CHARGES)              INVOICE_CHARGES,
           sum(Trans.INVOICE_CREDITS)                INVOICE_CREDITS,
           max(Trans.INSTALL_BILL_DATE)             INSTALL_BILL_DATE,
           max(Trans.OWNER_ORG_CODE)            OWNER_ORG_CODE,
           max(Trans.INVOICE_REFERENCE_NUM) INVOICE_REFERENCE_NUM,
           max(Trans.SOLICITOR_ID)                      SOLICITOR_ID,
           max(Trans.SOURCE_CODE)                     MEET_APPEAL,
           max(Trans.CAMPAIGN_CODE)                 MEET_CAMPAIGN,
           max(SUBSTRING(Trans.PRODUCT_CODE,1,charindex('/',Trans.PRODUCT_CODE)-1)) MEETING, '' as TITLE
    from Trans
    where Trans.TRANSACTION_TYPE = 'DIST' and Trans.JOURNAL_TYPE = 'IN'
        and Trans.SOURCE_SYSTEM = 'MEETING'
        and Trans.IS_FR_ITEM = 1
group by Trans.ST_ID, Trans.GL_ACCT_ORG_CODE, Trans.CAMPAIGN_CODE, Trans.SOURCE_CODE

GO
GRANT REFERENCES ON  [dbo].[vMeetDonation] TO [IMIS]
GRANT SELECT ON  [dbo].[vMeetDonation] TO [IMIS]
GRANT INSERT ON  [dbo].[vMeetDonation] TO [IMIS]
GRANT DELETE ON  [dbo].[vMeetDonation] TO [IMIS]
GRANT UPDATE ON  [dbo].[vMeetDonation] TO [IMIS]
GO